TYPE=VIEW
query=(select `db_iwms_new`.`tbl_reason`.`reason_id` AS `reason_id`,`db_iwms_new`.`tbl_reason`.`reason_inbound_type` AS `reason_inbound_type`,`db_iwms_new`.`tbl_reason`.`reason_warehouse_group_code` AS `reason_warehouse_group_code`,`db_iwms_new`.`tbl_reason`.`reason_content` AS `reason_content`,`db_iwms_new`.`tbl_reason`.`reason_use_company` AS `reason_use_company`,`db_iwms_new`.`tbl_reason`.`reason_order` AS `reason_order`,`db_iwms_new`.`tbl_reason`.`reason_status` AS `reason_status`,`db_iwms_new`.`tbl_reason`.`reason_code` AS `reason_code` from `db_iwms_new`.`tbl_reason` where (`db_iwms_new`.`tbl_reason`.`reason_status` = 1))
md5=ba55eb07e0034b26cd6aa553b67e2edb
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2011-10-22 15:30:53
create-version=1
source=(select `db_iwms_new`.`tbl_reason`.`reason_id` AS `reason_id`,`db_iwms_new`.`tbl_reason`.`reason_inbound_type` AS `reason_inbound_type`,`db_iwms_new`.`tbl_reason`.`reason_warehouse_group_code` AS `reason_warehouse_group_code`,`db_iwms_new`.`tbl_reason`.`reason_content` AS `reason_content`,`db_iwms_new`.`tbl_reason`.`reason_use_company` AS `reason_use_company`,`db_iwms_new`.`tbl_reason`.`reason_order` AS `reason_order`,`db_iwms_new`.`tbl_reason`.`reason_status` AS `reason_status`,`db_iwms_new`.`tbl_reason`.`reason_code` AS `reason_code` from `tbl_reason` where (`db_iwms_new`.`tbl_reason`.`reason_status` = 1))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=(select `db_iwms_new`.`tbl_reason`.`reason_id` AS `reason_id`,`db_iwms_new`.`tbl_reason`.`reason_inbound_type` AS `reason_inbound_type`,`db_iwms_new`.`tbl_reason`.`reason_warehouse_group_code` AS `reason_warehouse_group_code`,`db_iwms_new`.`tbl_reason`.`reason_content` AS `reason_content`,`db_iwms_new`.`tbl_reason`.`reason_use_company` AS `reason_use_company`,`db_iwms_new`.`tbl_reason`.`reason_order` AS `reason_order`,`db_iwms_new`.`tbl_reason`.`reason_status` AS `reason_status`,`db_iwms_new`.`tbl_reason`.`reason_code` AS `reason_code` from `db_iwms_new`.`tbl_reason` where (`db_iwms_new`.`tbl_reason`.`reason_status` = 1))
